

clear
set matsize 5000
cd <directory>

*********************************************************************************
**Table 1 - Panel 1 (Count of Sample sizes)
*********************************************************************************

use "LEDprojecwithtamudatanew.dta" , clear
count
preserve
duplicates drop rno, force
count
restore
preserve
duplicates drop Date, force
count
restore
preserve
duplicates drop unit, force
count
restore

*********************************************************************************
**Table 1 - Summary Statistics of the Weather Variables
*********************************************************************************

su meant relativehumidity wbgtmeant

*********************************************************************************
**Table 1 - Summary Statistics of the Weather Variables
*********************************************************************************

su mactualeff

*********************************************************************************
**Table 1 - Summary Statistics of the Production Variables
*********************************************************************************
su mactualeff mbudgeteff sam

*********************************************************************************
**Table 1 - Summary Statistics for Attendance
*********************************************************************************

use "linelevelattendancewithtamudatanew.dta" , clear
su meanp

